﻿CREATE TABLE [dbo].[AssetLog] (
    [Id]                  BIGINT           IDENTITY (1, 1) NOT NULL,
    [AssetId]             UNIQUEIDENTIFIER NOT NULL,
    [Name]                NVARCHAR (50)    NOT NULL,
    [SerialNumber]        NVARCHAR (50)    NOT NULL,
    [Number]              NVARCHAR (50)    NULL,
    [Type]                NVARCHAR (50)    NULL,
    [Model]               NVARCHAR (50)    NULL,
    [Lifespan]            INT              NULL,
    [SalvageValue]        MONEY            NULL,
    [NetBookValue]        MONEY            NULL,
    [DepreciationMonthly] MONEY            NULL,
    [DepreciationMonths]  INT              NULL,
    [CurrentOwnerId]      UNIQUEIDENTIFIER NULL,
    [CurrentProjectId]    UNIQUEIDENTIFIER NULL,
    [CurrentSubOfficeId]  UNIQUEIDENTIFIER NULL,
    [CurrentWareHouseId]  UNIQUEIDENTIFIER NULL
);

